﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="CDmShpChargeAlipayLog" targetNamespace="http://tempuri.org/CDmShpChargeAlipayLog.xsd" xmlns:mstns="http://tempuri.org/CDmShpChargeAlipayLog.xsd" xmlns="http://tempuri.org/CDmShpChargeAlipayLog.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="msBscConnectionString1" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="msBscConnectionString1 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.msBsc.Xsd.DataTds.Properties.Settings.GlobalReference.Default.msBscConnectionString1" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="SHP_CHARGE_ALIPAY_LOGTableAdapter" GeneratorDataComponentClassName="SHP_CHARGE_ALIPAY_LOGTableAdapter" Name="SHP_CHARGE_ALIPAY_LOG" UserDataComponentName="SHP_CHARGE_ALIPAY_LOGTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="msBscConnectionString1 (Settings)" DbObjectName="msBsc.dbo.SHP_CHARGE_ALIPAY_LOG" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[SHP_CHARGE_ALIPAY_LOG] WHERE (([ALIPAY_LOG_ID] = @Original_ALIPAY_LOG_ID) AND ((@IsNull_PAY_DIR = 1 AND [PAY_DIR] IS NULL) OR ([PAY_DIR] = @Original_PAY_DIR)) AND ((@IsNull_CHARGE_TRADING_ID = 1 AND [CHARGE_TRADING_ID] IS NULL) OR ([CHARGE_TRADING_ID] = @Original_CHARGE_TRADING_ID)) AND ((@IsNull_ALIPAY_TRADING_NO = 1 AND [ALIPAY_TRADING_NO] IS NULL) OR ([ALIPAY_TRADING_NO] = @Original_ALIPAY_TRADING_NO)) AND ((@IsNull_OUT_TRADING_NO = 1 AND [OUT_TRADING_NO] IS NULL) OR ([OUT_TRADING_NO] = @Original_OUT_TRADING_NO)) AND ((@IsNull_TRADING_AMT = 1 AND [TRADING_AMT] IS NULL) OR ([TRADING_AMT] = @Original_TRADING_AMT)) AND ((@IsNull_TRADING_NME = 1 AND [TRADING_NME] IS NULL) OR ([TRADING_NME] = @Original_TRADING_NME)) AND ((@IsNull_TRADING_DESC = 1 AND [TRADING_DESC] IS NULL) OR ([TRADING_DESC] = @Original_TRADING_DESC)) AND ((@IsNull_MALL_EMAIL = 1 AND [MALL_EMAIL] IS NULL) OR ([MALL_EMAIL] = @Original_MALL_EMAIL)) AND ((@IsNull_BUYER_EMAIL = 1 AND [BUYER_EMAIL] IS NULL) OR ([BUYER_EMAIL] = @Original_BUYER_EMAIL)) AND ((@IsNull_TRADING_STATUS = 1 AND [TRADING_STATUS] IS NULL) OR ([TRADING_STATUS] = @Original_TRADING_STATUS)) AND ((@IsNull_REFUND_STATUS = 1 AND [REFUND_STATUS] IS NULL) OR ([REFUND_STATUS] = @Original_REFUND_STATUS)) AND ((@IsNull_INITIAL_DT = 1 AND [INITIAL_DT] IS NULL) OR ([INITIAL_DT] = @Original_INITIAL_DT)) AND ((@IsNull_INITIAL_USR = 1 AND [INITIAL_USR] IS NULL) OR ([INITIAL_USR] = @Original_INITIAL_USR)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ALIPAY_LOG_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALIPAY_LOG_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAY_DIR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAY_DIR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PAY_DIR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAY_DIR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHARGE_TRADING_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHARGE_TRADING_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CHARGE_TRADING_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHARGE_TRADING_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALIPAY_TRADING_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALIPAY_TRADING_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ALIPAY_TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALIPAY_TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OUT_TRADING_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OUT_TRADING_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OUT_TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OUT_TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_AMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_AMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TRADING_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TRADING_AMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_DESC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_DESC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_DESC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_DESC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MALL_EMAIL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MALL_EMAIL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MALL_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MALL_EMAIL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BUYER_EMAIL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BUYER_EMAIL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BUYER_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUYER_EMAIL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_STATUS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_STATUS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REFUND_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REFUND_STATUS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_REFUND_STATUS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REFUND_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INITIAL_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_INITIAL_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INITIAL_USR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_INITIAL_USR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[SHP_CHARGE_ALIPAY_LOG] ([ALIPAY_LOG_ID], [PAY_DIR], [CHARGE_TRADING_ID], [ALIPAY_TRADING_NO], [OUT_TRADING_NO], [TRADING_AMT], [TRADING_NME], [TRADING_DESC], [MALL_EMAIL], [BUYER_EMAIL], [TRADING_STATUS], [REFUND_STATUS], [INITIAL_DT], [INITIAL_USR]) VALUES (@ALIPAY_LOG_ID, @PAY_DIR, @CHARGE_TRADING_ID, @ALIPAY_TRADING_NO, @OUT_TRADING_NO, @TRADING_AMT, @TRADING_NME, @TRADING_DESC, @MALL_EMAIL, @BUYER_EMAIL, @TRADING_STATUS, @REFUND_STATUS, @INITIAL_DT, @INITIAL_USR);
SELECT ALIPAY_LOG_ID, PAY_DIR, CHARGE_TRADING_ID, ALIPAY_TRADING_NO, OUT_TRADING_NO, TRADING_AMT, TRADING_NME, TRADING_DESC, MALL_EMAIL, BUYER_EMAIL, TRADING_STATUS, REFUND_STATUS, INITIAL_DT, INITIAL_USR FROM SHP_CHARGE_ALIPAY_LOG WHERE (ALIPAY_LOG_ID = @ALIPAY_LOG_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ALIPAY_LOG_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALIPAY_LOG_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PAY_DIR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAY_DIR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CHARGE_TRADING_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHARGE_TRADING_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ALIPAY_TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALIPAY_TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OUT_TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OUT_TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TRADING_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TRADING_AMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_DESC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_DESC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MALL_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MALL_EMAIL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BUYER_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUYER_EMAIL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_STATUS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@REFUND_STATUS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REFUND_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@INITIAL_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@INITIAL_USR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ALIPAY_LOG_ID, PAY_DIR, CHARGE_TRADING_ID, ALIPAY_TRADING_NO, OUT_TRADING_NO, TRADING_AMT, TRADING_NME, TRADING_DESC, MALL_EMAIL, BUYER_EMAIL, TRADING_STATUS, REFUND_STATUS, INITIAL_DT, INITIAL_USR FROM dbo.SHP_CHARGE_ALIPAY_LOG</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[SHP_CHARGE_ALIPAY_LOG] SET [ALIPAY_LOG_ID] = @ALIPAY_LOG_ID, [PAY_DIR] = @PAY_DIR, [CHARGE_TRADING_ID] = @CHARGE_TRADING_ID, [ALIPAY_TRADING_NO] = @ALIPAY_TRADING_NO, [OUT_TRADING_NO] = @OUT_TRADING_NO, [TRADING_AMT] = @TRADING_AMT, [TRADING_NME] = @TRADING_NME, [TRADING_DESC] = @TRADING_DESC, [MALL_EMAIL] = @MALL_EMAIL, [BUYER_EMAIL] = @BUYER_EMAIL, [TRADING_STATUS] = @TRADING_STATUS, [REFUND_STATUS] = @REFUND_STATUS, [INITIAL_DT] = @INITIAL_DT, [INITIAL_USR] = @INITIAL_USR WHERE (([ALIPAY_LOG_ID] = @Original_ALIPAY_LOG_ID) AND ((@IsNull_PAY_DIR = 1 AND [PAY_DIR] IS NULL) OR ([PAY_DIR] = @Original_PAY_DIR)) AND ((@IsNull_CHARGE_TRADING_ID = 1 AND [CHARGE_TRADING_ID] IS NULL) OR ([CHARGE_TRADING_ID] = @Original_CHARGE_TRADING_ID)) AND ((@IsNull_ALIPAY_TRADING_NO = 1 AND [ALIPAY_TRADING_NO] IS NULL) OR ([ALIPAY_TRADING_NO] = @Original_ALIPAY_TRADING_NO)) AND ((@IsNull_OUT_TRADING_NO = 1 AND [OUT_TRADING_NO] IS NULL) OR ([OUT_TRADING_NO] = @Original_OUT_TRADING_NO)) AND ((@IsNull_TRADING_AMT = 1 AND [TRADING_AMT] IS NULL) OR ([TRADING_AMT] = @Original_TRADING_AMT)) AND ((@IsNull_TRADING_NME = 1 AND [TRADING_NME] IS NULL) OR ([TRADING_NME] = @Original_TRADING_NME)) AND ((@IsNull_TRADING_DESC = 1 AND [TRADING_DESC] IS NULL) OR ([TRADING_DESC] = @Original_TRADING_DESC)) AND ((@IsNull_MALL_EMAIL = 1 AND [MALL_EMAIL] IS NULL) OR ([MALL_EMAIL] = @Original_MALL_EMAIL)) AND ((@IsNull_BUYER_EMAIL = 1 AND [BUYER_EMAIL] IS NULL) OR ([BUYER_EMAIL] = @Original_BUYER_EMAIL)) AND ((@IsNull_TRADING_STATUS = 1 AND [TRADING_STATUS] IS NULL) OR ([TRADING_STATUS] = @Original_TRADING_STATUS)) AND ((@IsNull_REFUND_STATUS = 1 AND [REFUND_STATUS] IS NULL) OR ([REFUND_STATUS] = @Original_REFUND_STATUS)) AND ((@IsNull_INITIAL_DT = 1 AND [INITIAL_DT] IS NULL) OR ([INITIAL_DT] = @Original_INITIAL_DT)) AND ((@IsNull_INITIAL_USR = 1 AND [INITIAL_USR] IS NULL) OR ([INITIAL_USR] = @Original_INITIAL_USR)));
SELECT ALIPAY_LOG_ID, PAY_DIR, CHARGE_TRADING_ID, ALIPAY_TRADING_NO, OUT_TRADING_NO, TRADING_AMT, TRADING_NME, TRADING_DESC, MALL_EMAIL, BUYER_EMAIL, TRADING_STATUS, REFUND_STATUS, INITIAL_DT, INITIAL_USR FROM SHP_CHARGE_ALIPAY_LOG WHERE (ALIPAY_LOG_ID = @ALIPAY_LOG_ID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ALIPAY_LOG_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALIPAY_LOG_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PAY_DIR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAY_DIR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CHARGE_TRADING_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHARGE_TRADING_ID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ALIPAY_TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALIPAY_TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OUT_TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OUT_TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@TRADING_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TRADING_AMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_NME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_DESC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_DESC" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MALL_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MALL_EMAIL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BUYER_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUYER_EMAIL" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TRADING_STATUS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@REFUND_STATUS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REFUND_STATUS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@INITIAL_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@INITIAL_USR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ALIPAY_LOG_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALIPAY_LOG_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PAY_DIR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PAY_DIR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PAY_DIR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PAY_DIR" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CHARGE_TRADING_ID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CHARGE_TRADING_ID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CHARGE_TRADING_ID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CHARGE_TRADING_ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ALIPAY_TRADING_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ALIPAY_TRADING_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ALIPAY_TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ALIPAY_TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OUT_TRADING_NO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OUT_TRADING_NO" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OUT_TRADING_NO" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OUT_TRADING_NO" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_AMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_AMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_TRADING_AMT" Precision="18" ProviderType="Decimal" Scale="2" Size="0" SourceColumn="TRADING_AMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_NME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_NME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_NME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_NME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_DESC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_DESC" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_DESC" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_DESC" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MALL_EMAIL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MALL_EMAIL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MALL_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MALL_EMAIL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BUYER_EMAIL" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BUYER_EMAIL" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BUYER_EMAIL" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUYER_EMAIL" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TRADING_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TRADING_STATUS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TRADING_STATUS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TRADING_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_REFUND_STATUS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="REFUND_STATUS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_REFUND_STATUS" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="REFUND_STATUS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INITIAL_DT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_INITIAL_DT" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="INITIAL_DT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_INITIAL_USR" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_INITIAL_USR" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="INITIAL_USR" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ALIPAY_LOG_ID" DataSetColumn="ALIPAY_LOG_ID" />
              <Mapping SourceColumn="PAY_DIR" DataSetColumn="PAY_DIR" />
              <Mapping SourceColumn="CHARGE_TRADING_ID" DataSetColumn="CHARGE_TRADING_ID" />
              <Mapping SourceColumn="ALIPAY_TRADING_NO" DataSetColumn="ALIPAY_TRADING_NO" />
              <Mapping SourceColumn="OUT_TRADING_NO" DataSetColumn="OUT_TRADING_NO" />
              <Mapping SourceColumn="TRADING_AMT" DataSetColumn="TRADING_AMT" />
              <Mapping SourceColumn="TRADING_NME" DataSetColumn="TRADING_NME" />
              <Mapping SourceColumn="TRADING_DESC" DataSetColumn="TRADING_DESC" />
              <Mapping SourceColumn="MALL_EMAIL" DataSetColumn="MALL_EMAIL" />
              <Mapping SourceColumn="BUYER_EMAIL" DataSetColumn="BUYER_EMAIL" />
              <Mapping SourceColumn="TRADING_STATUS" DataSetColumn="TRADING_STATUS" />
              <Mapping SourceColumn="REFUND_STATUS" DataSetColumn="REFUND_STATUS" />
              <Mapping SourceColumn="INITIAL_DT" DataSetColumn="INITIAL_DT" />
              <Mapping SourceColumn="INITIAL_USR" DataSetColumn="INITIAL_USR" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="CDmShpChargeAlipayLog" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="CDmShpChargeAlipayLog" msprop:Generator_UserDSName="CDmShpChargeAlipayLog">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="SHP_CHARGE_ALIPAY_LOG" msprop:Generator_TableClassName="SHP_CHARGE_ALIPAY_LOGDataTable" msprop:Generator_TableVarName="tableSHP_CHARGE_ALIPAY_LOG" msprop:Generator_TablePropName="SHP_CHARGE_ALIPAY_LOG" msprop:Generator_RowDeletingName="SHP_CHARGE_ALIPAY_LOGRowDeleting" msprop:Generator_RowChangingName="SHP_CHARGE_ALIPAY_LOGRowChanging" msprop:Generator_RowEvHandlerName="SHP_CHARGE_ALIPAY_LOGRowChangeEventHandler" msprop:Generator_RowDeletedName="SHP_CHARGE_ALIPAY_LOGRowDeleted" msprop:Generator_UserTableName="SHP_CHARGE_ALIPAY_LOG" msprop:Generator_RowChangedName="SHP_CHARGE_ALIPAY_LOGRowChanged" msprop:Generator_RowEvArgName="SHP_CHARGE_ALIPAY_LOGRowChangeEvent" msprop:Generator_RowClassName="SHP_CHARGE_ALIPAY_LOGRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ALIPAY_LOG_ID" msprop:Generator_ColumnVarNameInTable="columnALIPAY_LOG_ID" msprop:Generator_ColumnPropNameInRow="ALIPAY_LOG_ID" msprop:Generator_ColumnPropNameInTable="ALIPAY_LOG_IDColumn" msprop:Generator_UserColumnName="ALIPAY_LOG_ID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PAY_DIR" msprop:Generator_ColumnVarNameInTable="columnPAY_DIR" msprop:Generator_ColumnPropNameInRow="PAY_DIR" msprop:Generator_ColumnPropNameInTable="PAY_DIRColumn" msprop:Generator_UserColumnName="PAY_DIR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CHARGE_TRADING_ID" msprop:Generator_ColumnVarNameInTable="columnCHARGE_TRADING_ID" msprop:Generator_ColumnPropNameInRow="CHARGE_TRADING_ID" msprop:Generator_ColumnPropNameInTable="CHARGE_TRADING_IDColumn" msprop:Generator_UserColumnName="CHARGE_TRADING_ID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ALIPAY_TRADING_NO" msprop:Generator_ColumnVarNameInTable="columnALIPAY_TRADING_NO" msprop:Generator_ColumnPropNameInRow="ALIPAY_TRADING_NO" msprop:Generator_ColumnPropNameInTable="ALIPAY_TRADING_NOColumn" msprop:Generator_UserColumnName="ALIPAY_TRADING_NO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OUT_TRADING_NO" msprop:Generator_ColumnVarNameInTable="columnOUT_TRADING_NO" msprop:Generator_ColumnPropNameInRow="OUT_TRADING_NO" msprop:Generator_ColumnPropNameInTable="OUT_TRADING_NOColumn" msprop:Generator_UserColumnName="OUT_TRADING_NO" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TRADING_AMT" msprop:Generator_ColumnVarNameInTable="columnTRADING_AMT" msprop:Generator_ColumnPropNameInRow="TRADING_AMT" msprop:Generator_ColumnPropNameInTable="TRADING_AMTColumn" msprop:Generator_UserColumnName="TRADING_AMT" type="xs:decimal" minOccurs="0" />
              <xs:element name="TRADING_NME" msprop:Generator_ColumnVarNameInTable="columnTRADING_NME" msprop:Generator_ColumnPropNameInRow="TRADING_NME" msprop:Generator_ColumnPropNameInTable="TRADING_NMEColumn" msprop:Generator_UserColumnName="TRADING_NME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TRADING_DESC" msprop:Generator_ColumnVarNameInTable="columnTRADING_DESC" msprop:Generator_ColumnPropNameInRow="TRADING_DESC" msprop:Generator_ColumnPropNameInTable="TRADING_DESCColumn" msprop:Generator_UserColumnName="TRADING_DESC" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MALL_EMAIL" msprop:Generator_ColumnVarNameInTable="columnMALL_EMAIL" msprop:Generator_ColumnPropNameInRow="MALL_EMAIL" msprop:Generator_ColumnPropNameInTable="MALL_EMAILColumn" msprop:Generator_UserColumnName="MALL_EMAIL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BUYER_EMAIL" msprop:Generator_ColumnVarNameInTable="columnBUYER_EMAIL" msprop:Generator_ColumnPropNameInRow="BUYER_EMAIL" msprop:Generator_ColumnPropNameInTable="BUYER_EMAILColumn" msprop:Generator_UserColumnName="BUYER_EMAIL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TRADING_STATUS" msprop:Generator_ColumnVarNameInTable="columnTRADING_STATUS" msprop:Generator_ColumnPropNameInRow="TRADING_STATUS" msprop:Generator_ColumnPropNameInTable="TRADING_STATUSColumn" msprop:Generator_UserColumnName="TRADING_STATUS" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="REFUND_STATUS" msprop:Generator_ColumnVarNameInTable="columnREFUND_STATUS" msprop:Generator_ColumnPropNameInRow="REFUND_STATUS" msprop:Generator_ColumnPropNameInTable="REFUND_STATUSColumn" msprop:Generator_UserColumnName="REFUND_STATUS" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="INITIAL_DT" msprop:Generator_ColumnVarNameInTable="columnINITIAL_DT" msprop:Generator_ColumnPropNameInRow="INITIAL_DT" msprop:Generator_ColumnPropNameInTable="INITIAL_DTColumn" msprop:Generator_UserColumnName="INITIAL_DT" type="xs:dateTime" minOccurs="0" />
              <xs:element name="INITIAL_USR" msprop:Generator_ColumnVarNameInTable="columnINITIAL_USR" msprop:Generator_ColumnPropNameInRow="INITIAL_USR" msprop:Generator_ColumnPropNameInTable="INITIAL_USRColumn" msprop:Generator_UserColumnName="INITIAL_USR" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SHP_CHARGE_ALIPAY_LOG" />
      <xs:field xpath="mstns:ALIPAY_LOG_ID" />
    </xs:unique>
  </xs:element>
</xs:schema>